﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace MesGLApp.DAL.MesDB
{
    [Serializable]
    [Table("smt_pcb_scan")]
    [SugarTable("smt_pcb_scan")]
    public class SmtPcbScan
    {
        /// <summary>
        /// id，主键，自增长
        /// </summary>
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int id { get; set; }

        /// <summary>
        /// 引用PCB板确认记录的ID，即表smt_pcb_confirm表的id字段
        /// </summary>
        public int confirm_id { get; set; }


        /// <summary>
        /// 引用工单ID，即表target_prod_process表的id字段
        /// </summary>
        public int prod_id { get; set; }

        /// <summary>
        /// 工单号
        /// </summary>
        public string prod_number { get; set; }

        /// <summary>
        /// 物料编号 
        /// </summary>
        public string mat_number { get; set; }

        /// <summary>
        /// 扫码站点ID
        /// </summary>
        public int site_id { get; set; }

        /// <summary>
        /// 扫码站点名称
        /// </summary>
        public string site_name { get; set; }

        /// <summary>
        /// PCB板的扫码数量
        /// </summary>
        public decimal? pcb_scan_qty { get; set; }

        /// <summary>
        /// 扫码时间
        /// </summary>
        public DateTime? scan_date { get; set; }

        /// <summary>
        /// 建档人
        /// </summary>
        public string create_user { get; set; }

        /// <summary>
        /// 建档日期
        /// </summary>
        public DateTime? create_date { get; set; }

        /// <summary>
        /// 更新人
        /// </summary>
        public string update_user { get; set; }

        /// <summary>
        /// 更改日期
        /// </summary>
        public DateTime? update_date { get; set; }
    }
}
